package com.ssh.dao;

import java.util.List;

import com.ssh.entity.Position;
import com.ssh.entity.Staff;
import com.ssh.model.pdata.CSVWmatePData;
import com.ssh.model.pdata.InnerDiverMPData;
import com.ssh.model.pdata.StaffMPData;

public interface StaffDAOI {

	public Staff queryStaffByStaffId(String staffId);
	public Staff updateStaff(Staff staff);
	public int deleteStaffByStaffId(String staffId);
	public Staff addStaff(Staff staff);
	public List<Staff> queryStaff(String ...strings);
	public int updateStaff(Staff ...staffs);
	public int deleteStaff(String ...strings);
	public int addStaff(Staff ...staffs);
	public List<Staff> queryStaffByExtra(String extra);

	public StaffMPData querySMPDataById(String staffId);
	public List<StaffMPData> getAllStaffMPData();
	public List<StaffMPData> queryBySex(String sex);
	public List<StaffMPData> queryByDep(String dep);
	public List<StaffMPData> queryBySexDep(String sex ,String dep);

	public List<CSVWmatePData> queryCSVWDataById(String dimId);
	public List<CSVWmatePData> getAllWmatePData();
	public List<CSVWmatePData> queryWMPDataByTel(String dimTel);
	public List<CSVWmatePData> queryWMPDataByFName(String dimFName);
	public List<CSVWmatePData> queryWMPDataByLName(String dimFLame);
	/**
	 * @param staffId
	 * @return 按员工编号查询内部驾驶员信息
	 */
	public InnerDiverMPData queryInnerDById(String staffId);
	/**
	 * @return 查询出所有内部驾驶员信息
	 */
	public List<InnerDiverMPData> queryAllInnerDriver();
	/**
	 * @param state
	 * @return 按状态沙勋内部驾驶员
	 */
	public List<InnerDiverMPData> queryInnerDriverByState(String state);


}
